Tabela PriceList

Definicja tabeli PriceList

Name

PriceList

Code

PriceList

Comment

PL: Dane cenników. Cenniki moga byc zarówno dla uslug "surowych" jak i dla opcji (uslug w bf) lub grup opcji.
EN: Price lists data


Lista kolumn tabeli PriceList

Name

Code

PriceListID

PriceListID

PackageKind

PriceListKindID

TimeslotTypeID

TimeslotTypeID

PersonID

PersonID

MedResourceID

MedResourceID

FullName

FullName

StartDT

StartDT

StopDT

StopDT

StartT

StartT

StopT

StopT

Notes

Notes

HolidayPriceList

HolidayPriceList

Code

Code

Active

Active


Kolumna PriceListID tabeli PriceList

Definicja kolumny PriceListID tabeli PriceList

Name

PriceListID

Code

PriceListID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PackageKind tabeli PriceList

Definicja kolumny PackageKind tabeli PriceList

Name

PackageKind

Code

PriceListKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna TimeslotTypeID tabeli PriceList

Definicja kolumny TimeslotTypeID tabeli PriceList

Name

TimeslotTypeID

Code

TimeslotTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli PriceList

Definicja kolumny PersonID tabeli PriceList

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MedResourceID tabeli PriceList

Definicja kolumny MedResourceID tabeli PriceList

Name

MedResourceID

Code

MedResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna FullName tabeli PriceList

Definicja kolumny FullName tabeli PriceList

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna StartDT tabeli PriceList

Definicja kolumny StartDT tabeli PriceList

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli PriceList

Definicja kolumny StopDT tabeli PriceList

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna StartT tabeli PriceList

Definicja kolumny StartT tabeli PriceList

Name

StartT

Code

StartT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna StopT tabeli PriceList

Definicja kolumny StopT tabeli PriceList

Name

StopT

Code

StopT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Notes tabeli PriceList

Definicja kolumny Notes tabeli PriceList

Name

Notes

Code

Notes

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna HolidayPriceList tabeli PriceList

Definicja kolumny HolidayPriceList tabeli PriceList

Name

HolidayPriceList

Code

HolidayPriceList

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Code tabeli PriceList

Definicja kolumny Code tabeli PriceList

Name

Code

Code

Code

Data Type

VARCHAR2(32)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna Active tabeli PriceList

Definicja kolumny Active tabeli PriceList

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Lista kluczy tabeli PriceList

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PriceList

Definicja klucza Identifier_1 tabeli PriceList

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment